{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Notes","Contribution Information Form","Counter Batch Sheets","Weekly Contribution Summary","Memorial Form"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":2,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Notes","index":0,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":false,"merged":[[42,4,42,11],[43,3,43,11],[23,3,23,11],[20,2,20,11],[30,3,30,11],[22,3,22,11],[28,3,28,11],[29,3,29,11],[39,2,39,11],[40,3,40,11],[5,1,5,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[4,0,4,11],[6,2,6,11],[8,1,8,11],[13,1,13,11],[14,2,14,11],[9,2,9,11],[10,2,10,11],[11,3,11,11],[16,2,16,11],[15,2,15,11],[21,2,21,11],[27,3,27,11],[24,3,24,11],[25,3,25,11],[26,2,26,11],[19,1,19,11],[18,0,18,11],[41,3,41,11],[32,1,32,11],[33,2,33,11],[34,3,34,11],[35,3,35,11],[36,3,36,11],[37,3,37,11],[38,3,38,11],[48,2,48,11],[44,3,44,11],[45,4,45,11],[46,4,46,11],[47,4,47,11],[52,3,52,11],[53,3,53,11],[54,3,54,11],[49,2,49,11],[50,3,50,11],[51,3,51,11]],"flags":["formulas_cached_only"]}
["Lutheran Church of the Resurrection"]
["Roles and Responsibilities for Trustees"]
["Related to the Counting Process"]
[]
["Lead Trustee in charge of Counters:"]
["1.  ","Send letters to the counters in November requesting months they can count for the coming year."]
[null,"a.  ","Secretary will provide envelopes and labels for the names."]
[]
["2.  ","Have trustees choose their desired months."]
[null,"a.  ","Recommend that they choose two consecutive months as this helps with the training and experience."]
[null,"b.  ","Recommend that an experienced trustee (one who has had the trustee responsibility for counting before) be present for the first counting session for each new trustee or a shadowing experience with another experienced Trustee has taken place prior to the first counting experience.    This is a control to ensure that all new trustees understand the process and follow it appropriately."]
[null,null,null,"NOTE:  Usually have 2 new trustees each year."]
[]
["3.  ","Develop the counting schedule for the new year and communicate."]
[null,"a.  ","If you received no counting forms for some that you know wants to count or late forms, can give them the month(s) that they had the previous year or just put them where they are needed the most."]
[null,"b.  ","Call all counters and trustees that will be handling February as the mailing of the schedule does not come out until later in January.  Want to give them sufficient notice."]
[null,"c.  ","Mail out schedule to all counters and trustees.  This should be done by the end of January."]
[]
["Counting procedures for Trustee assigned each month(s):"]
["1.  ","You are responsible for all services.  This includes Saturday evening (5:00 p.m.) and all Sunday services for the months assigned.  This also includes any special services such as those for Lent, Christmas, etc."]
[null,"a.    ","The Trustee should check with Pastor if additional services will be taking place during the Trustee's assigned months and verify the date and time of the additional services."]
[null,"b.  ","For the Saturday night service (or Special services during the week, such as Lent):"]
[null,null,"1.  ","As a general rule, Trustee should arrive around 5:15 p.m. for the 5:00 p.m. service."]
[null,null,"2.  ","Past Trustees have used Saturday night to prepare the room for counting on Sunday.  For example, getting the calculators out and plugged in, making sure there is tape rolls in all the calculators, having enough batch slips available, etc."]
[null,null,"3.  ","The Trustee must get the collection plates from the back of the church after the service and lock the money in the safe.  The Trustee is to return the empty collection plates to the alter."]
[null,null,"4.  ","If the trustee is in the church after the custodian has left, it is the Trustee's responsibility to ensure that the church is properly locked before leaving."]
[null,"b.  ","For the Sunday services:"]
[null,null,"1.  ","As a general rule, Trustee should arrive around 8:20 a.m. for the 8:00 p.m. service."]
[null,null,"2.  ","Ensure that the counting room is prepared and ready (see note above regarding suggestion to do this on Sunday evening)."]
[null,null,"3.  ","The Trustee must get the collection plates from the ushers (stand at the back of the church) and take it to the counting room after each service scheduled for Sunday.  The Trustee is to return the empty collection plates to the alter and ensure the counting room is locked at all times.  NOTE:  The 8:00 a.m. Sunday service is more formal and therefore the collection plates are on the alter during the entire service.  The Trustee is to pick these up after the service has ended.  The other services on Sunday, the Trustee is to pick them up at the collection during the services."]
[null,null,"4.  ","After the final service collection is completed, the Trustee is responsible for ensure the proper and accurate counting of the collections for the weeks services (see detailed tasks/steps below)."]
[]
["2.  ","Counting Contributions:"]
[null,"a.    ","Ensure Counters understand their duties and the proper process for counting:"]
[null,null,"1.  ","Ensure that all counters check each envelope for checks and cash.  They should place a check mark (    ) on the envelopes that contain checks and a dollar sign ($) on the envelopes that contain cash.  This is a control to assist with identification of errors during the counting process."]
[null,null,"2.  ","Ensure that all counters verify that the money amounts on the envelopes are easily readable.  This also is a control which assists with identification of errors during the counting process as well as the control to ensure that individual statements are accurate."]
[null,null,"3.  ","All groups of envelopes should be rubber banded together along with the tape and batch slip.  The batch slip should be clearly marked with coin, cash, check and grand total for that group."]
[null,null,"4.  ","All \"good\" money Coin, Cash, and Checks should be totaled and verified separately."]
[null,null,"5.  ","After Trustee has completed the weekly contributions form and has confirmed the accuracy of the counting, all counters are to sign the contributions form."]
[null,"b.  ","Trustee should complete a Contribution Information Form (see attached) for each check received without a member envelope."]
[null,null,"1.  ","Contribution Information Forms can be found in the cabinet (may need to make more copies)."]
[null,null,"2.  ","Look up name on check in the member listing (back of Trustee Binder) to see if they are listed as a member and then record the proper envelope number - this ensures that they will receive proper accounting for their contributions."]
[{"$nulls":4},"NOTE:  Secretary updates the member list every 6 months or so."]
[null,null,"3.  ","If the name on the check is not found on the member list, put N/A on space for envelope number on the voucher slip.  Complete remainder of Contribution Information Form."]
[null,null,"4.  ","There are three different ways the next step should be handled depending on the situation:"]
[null,null,null,"a.  ","If the contribution is for a special offering/collection (see Weekly Contribution Form) and then Trustee records this item on the Weekly Contribution Form and then the cash is considered \"good\" money.  Caution:  Once a batch or item is recorded on the Weekly Contribution Form it is considered \"good\" money.  If it is mistakenly put into the \"Loose\" money, you will double count it on the Weekly Contribution Form and will not balance."]
[null,null,null,"b.  ","If the contribution is not for a special offering/collection and has an identified member envelop number, the Trustee should not record anything on the Weekly Contribution Summary but instead simply include this (both the money and the Contribution Information Form) with the appropriate batch of envelopes.  In this case it is not \"good\" money and should be included in the totals for the envelope batch that is prepared by the counter."]
[null,null,null,"b.  ","If the contribution is not for a special offering/collection and does not have an identified member envelop number, the Trustee should not record anything on the Weekly Contribution Summary but instead simply include this (both the money and the Contribution Information Form) with the appropriate \"loose\" money.  "]
[null,"b.  ","Betty Schneider will bring up the Sunday School money collected. This is usually already counted but someone verifies the counting and then this is included as \"loose\" money.  For Summer months there is no Sunday School."]
[null,"c.  ","Trustee should complete the Weekly Contribution Summary and ensure that the information is accurate.  "]
[null,null,"1.  ","Trustee and counters need to work together to find and correct any errors."]
[null,null,"2.  ","Trustee and counters should sign the Weekly Contribution Summary confirming they agree with the accurate counting and recording of the contributions for that week."]
[null,null,"3.  ","The Trustee is to bundle all the envelop batches and including any Contribution Information Forms together with the signed Weekly Contribution Summary in one rubber band.  This should be placed on Secretary's desk in the church office."]
[null,null,"4.  ","The Trustee is to place all the money in the deposit bag  and fill out a deposit slip (both found in cabinet containing the safe).  Deposit Slip should be placed in the deposit bag with the money."]
[null,null,"5.  ","The Trustee is responsible for taking the deposit bag and putting it in the nightly deposit box at the Johnson Bank on Highway 20 and Sunnyslope Road (by McDonald's)."]

{"sheet":"Contribution Information Form","index":1,"n_rows":45,"n_cols":7,"rows_kept":45,"cut":false,"hidden":false,"merged":[[32,0,32,7],[38,0,38,1],[38,3,38,4],[40,4,40,5],[16,0,16,7],[22,0,22,1],[22,3,22,4],[24,4,24,5],[6,3,6,4],[6,0,6,1],[0,0,0,7],[8,4,8,5]],"flags":["formulas_cached_only"]}
["Contribution Information Form"]
[]
[]
["Date",null,null,"Envelop #",null,null,"Amount $"]
[]
[]
["Last Name",null,null,"First Name",null,null,"M. Initial"]
[]
["General",null,null,null,"Capital Appeal"]
[]
["Flowers",null,null,"Holman",null,null,"Other"]
[]
["Visitor",null,null,"ELCA Hunger",null,null,"Rooted & Growing"]
[]
[]
[]
["Contribution Information Form"]
[]
[]
["Date",null,null,"Envelop #",null,null,"Amount $"]
[]
[]
["Last Name",null,null,"First Name",null,null,"M. Initial"]
[]
["General",null,null,null,"Capital Appeal"]
[]
["Flowers",null,null,"Holman",null,null,"Other"]
[]
["Visitor",null,null,"ELCA Hunger",null,null,"Rooted & Growing"]
[]
[]
[]
["Contribution Information Form"]
[]
[]
["Date",null,null,"Envelop #",null,null,"Amount $"]
[]
[]
["Last Name",null,null,"First Name",null,null,"M. Initial"]
[]
["General",null,null,null,"Capital Appeal"]
[]
["Flowers",null,null,"Holman",null,null,"Other"]
[]
["Visitor",null,null,"ELCA Hunger",null,null,"Rooted & Growing"]

{"sheet":"Counter Batch Sheets","index":2,"n_rows":27,"n_cols":9,"rows_kept":27,"cut":false,"hidden":false,"merged":[[9,2,9,4],[9,8,9,10],[10,2,10,4],[10,8,10,10],[0,0,0,1],[2,2,2,4],[3,2,3,4],[4,2,4,4],[0,2,0,5],[0,6,0,7],[0,8,0,11],[2,8,2,10],[3,8,3,10],[4,8,4,10],[5,8,5,10],[7,0,7,1],[7,2,7,5],[7,6,7,7],[7,8,7,11],[5,2,5,4],[11,2,11,4],[11,8,11,10],[12,2,12,4],[12,8,12,10],[14,0,14,1],[14,2,14,5],[14,6,14,7],[14,8,14,11],[16,2,16,4],[16,8,16,10],[17,2,17,4],[17,8,17,10],[18,2,18,4],[18,8,18,10],[19,2,19,4],[19,8,19,10],[21,0,21,1],[21,2,21,5],[21,6,21,7],[21,8,21,11],[23,2,23,4],[23,8,23,10],[24,2,24,4],[24,8,24,10],[25,2,25,4],[25,8,25,10],[26,2,26,4],[26,8,26,10]],"flags":["formulas_cached_only"]}
["Envelope Series:  ",null,"______________",null,null,null,"Envelope Series:  ",null,"______________"]
[]
[null,"Cash:  ","   __________",{"$nulls":4},"Cash:  ","   __________"]
[null,"Coin:  ","   __________",{"$nulls":4},"Coin:  ","   __________"]
[null,"Check:  ","   __________",{"$nulls":4},"Check:  ","   __________"]
[null,"Total:  ","   __________",{"$nulls":4},"Total:  ","   __________"]
[]
["Envelope Series:  ",null,"______________",null,null,null,"Envelope Series:  ",null,"______________"]
[]
[null,"Cash:  ","   __________",{"$nulls":4},"Cash:  ","   __________"]
[null,"Coin:  ","   __________",{"$nulls":4},"Coin:  ","   __________"]
[null,"Check:  ","   __________",{"$nulls":4},"Check:  ","   __________"]
[null,"Total:  ","   __________",{"$nulls":4},"Total:  ","   __________"]
[]
["Envelope Series:  ",null,"______________",null,null,null,"Envelope Series:  ",null,"______________"]
[]
[null,"Cash:  ","   __________",{"$nulls":4},"Cash:  ","   __________"]
[null,"Coin:  ","   __________",{"$nulls":4},"Coin:  ","   __________"]
[null,"Check:  ","   __________",{"$nulls":4},"Check:  ","   __________"]
[null,"Total:  ","   __________",{"$nulls":4},"Total:  ","   __________"]
[]
["Envelope Series:  ",null,"______________",null,null,null,"Envelope Series:  ",null,"______________"]
[]
[null,"Cash:  ","   __________",{"$nulls":4},"Cash:  ","   __________"]
[null,"Coin:  ","   __________",{"$nulls":4},"Coin:  ","   __________"]
[null,"Check:  ","   __________",{"$nulls":4},"Check:  ","   __________"]
[null,"Total:  ","   __________",{"$nulls":4},"Total:  ","   __________"]

{"sheet":"Weekly Contribution Summary","index":3,"n_rows":92,"n_cols":6,"rows_kept":92,"cut":false,"hidden":false,"merged":[[7,5,8,5],[7,4,8,4],[71,0,71,1],[33,2,34,2],[33,3,34,3],[40,0,40,1],[0,0,0,5],[2,0,2,5],[46,0,46,5],[33,4,34,4],[33,5,34,5],[20,0,20,1],[31,0,31,1],[7,2,8,2],[7,3,8,3],[1,0,1,5]],"flags":["formulas_cached_only"]}
["LUTHERAN CHURCH OF THE RESURRECTION"]
["Weekly Contribution Summary"]
["Sunday's Date  _______________________"]
[]
[{"$nulls":4},"Deposit #","___________"]
["Counters' Form Page 1",null,null,null,"Batch #","___________"]
[]
["REGULAR OFFERINGS",null,"Currency","Coin","Checks","Total"]
["015-01-01-00","Regular Envelopes"]
[null,"100's"]
[null,"200's"]
[null,"300's"]
[null,"400's"]
[null,"500's"]
[null,"600's"]
[null,"700's"]
[null,"800's"]
[null,"900's"]
[null,"Others"]
["017-99-00-99","Capital Appeal"]
["Sub-total Regular Offerings",null,"A1","A2","A3","A4"]
[]
["SPECIAL OFFERINGS",null,"Currency","Coin","Checks","Total"]
["015-00-01-05","Ash Wednesday"]
["015-00-01-05","Lent"]
["015-00-01-05","Maundy Thursday"]
["015-00-01-05","Good Friday"]
["015-00-01-02","Easter"]
["015-00-01-03","Thanksgiving"]
["015-00-01-01","Advent"]
["015-00-01-04","Christmas"]
["Sub-total Special Offerings",null,"B1","B2","B3","B4"]
[]
["MISCELLANEOUS OFFERINGS",null,"Currency","Coin","Checks","Total"]
["015-00-02-08","Miscellaneous"]
["For:"]
["For:"]
["For:"]
["015-00-02-09","Special Appeal"]
["015-00-02-06","Loose Offerings"]
["Sub-total Misc. Offerings",null,"C1","C2","C3","C4"]
[]
[null,"Totals","Currency","Coin","Checks","Total"]
[null,"Total Page 1","A1+B1+C1","A2+B2+C2","A3+B3+C3","A4+B4+C4"]
[null,"Total Page 2","D1","D2","D3","D4"]
[null,"Grand Total","A1+B1+C1+D1","A2+B2+C2+D2","A3+B3+C3+D3","A4+B4+C4+D4"]
["LUTHERAN CHURCH OF THE RESURRECTION"]
[]
[]
["Counters' Form Page 2"]
[]
["SPECIFIC OFFERINGS",null,"Currency","Coin","Checks","Total"]
["015-00-02-08","Flowers"]
["015-00-02-07","Sunday School"]
[null,"Memorials"]
["017-99-00-39","Air Conditioning"]
["017-99-00-15","Good Samaritan"]
["017-99-00-16","Food Cupboard"]
["017-99-00-40","Youth"]
["017-99-00-10","Leaf"]
["017-99-00-05","Amundson Fund"]
["017-99-00-22","Holman's"]
{"$rows_empty":9}
["Sub-total Specific Offerings - TOTAL PAGE 2",null,"D1","D2","D3","D4"]
[]
[]
[]
["Signature of Counters:",null,null,"Signature of Trustee:"]
[]
["1)  _______________________________",null,null,"__________________________________"]
[]
["2)  _______________________________"]
[]
["3)  _______________________________",null,null,"Date Counted:  _____________________"]
[]
["4)  _______________________________"]
[]
["5)  _______________________________"]
[]
["6)  _______________________________"]
[]
[]
[]
[{"$nulls":5},"Date Form Revised:  August 21, 2006"]

{"sheet":"Memorial Form","index":4,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":false,"merged":[[2,0,3,0],[0,0,0,7],[2,1,2,3],[2,4,3,4],[2,5,3,5],[2,6,3,6]],"flags":["formulas_cached_only"]}
["Memorial Funds"]
[]
["Today's Date","From",null,null,"In Memory of:","Designated for:","Amount Given","Recorded"]
[null,"Name","Address","Phone #",null,null,null,"Office Use Only"]